<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8"/>
		<title>操機員排配表</title>
		<meta name="viewport" content="width=device-width, initial-scale=1"/>
		<meta http-equiv="X-UA-Compatible" content="IE=edge" />
		<meta http-equiv="pragma" content="no-cache"/>
		<meta http-equiv="cache-control" content="no-cache"/>
		<meta http-equiv="expires" content="0"/>	
		<link rel="stylesheet" href="./4/lumen/bootstrap.css" media="screen"/>
		<link rel="stylesheet" href="./_assets/css/custom.min.css"/>
	</head>
<body>
	<div class="container">
		<form>
			<legend>操機員排配表</legend>
			<div class="form-group row">
				<label class="col-sm-1 col-form-label" for="inputDefault">工序:</label>
				<div class="col-sm-2">
					<select name="WP" class="form-control" id="WP" type="text">
						<option value="齐纳">齐纳</option>
						<option value="固晶">固晶</option>
						<option value="焊线">焊线</option>
						<option value="点胶">点胶</option>
						<option value="切割">切割</option>
						<option value="分光">分光</option>
						<option value="编带">编带</option>
					</select>
				</div>
			  <label class="col-sm-1 col-form-label" for="inputDefault">班別:</label>
			  <div class="col-sm-1">
			  <input type="radio" class="form-check-input" name="classRadios" id="optionsRadios1" value="白">
				<label class="custom-control-label" for="customRadio1">白</label><br>
			  <input type="radio" class="form-check-input" name="classRadios" id="optionsRadios2" value="夜">
				<label class="custom-control-label" for="customRadio1">夜</label>
			  </div>
				<div class="col-sm-2">
					<button type="button" id="Today_Work_People" >查詢今日操机员排配</button>
			    </div>
				<!-- 2018-3-14 16:27:31注釋:PHP要切開 -->
				<div class="col-sm-2">
					<button type="button" id="Yesterday_Work_People" >查詢昨日操机员排配</button>
				</div>
			</div>	
			
			<div class="form-group row">
			  <label class="col-sm-1 col-form-label" for="inputDefault">日期:</label>
			  <div class="col-sm-2">
				<input   class="form-control"  id="RiQi" type="text"/>
			  </div>
			</div>
			<div id="mytable"></div>
			
		</form>
			<br></br>
			<div class="form-group row">
			  <div class="col-sm-2">
				<button type="button" id="keep" >保存</button>
			  </div>
			  <div class="col-sm-2">
				<input readonly="" class="form-control-plaintext" id="msg" value="" type="text">
			  </div>
			  <div class="col-sm-2">
				<button type="button" id="save" >提交</button>
			  </div>
			</div>
			<div class="form-group row">
			</div>
		
		<p class="lead">
			<a class="btn btn-primary btn-lg" href="index.html" role="button">返回</a>
		</p>
	</div>
	
	<link rel="stylesheet" type="text/css" href="./jexcel-master/dist/css/jquery.jexcel.css" />
    <script src="./_vendor/jquery/dist/jquery.min.js"></script>
	<script src="./jexcel-master/dist/js/jquery.jexcel.js"></script>
    <script src="./_vendor/popper.js/dist/umd/popper.min.js"></script>
    <script src="./_vendor/bootstrap/dist/js/bootstrap.min.js"></script>
    <script src="./_assets/js/custom.js"></script>
	
<script>

	Plan_data = null; 
	//encodeURIComponent編碼
	//decodeURIComponent後端解碼
	//2018-3-8 21:28:30注釋:為了方便修改,將每個字段頭拆成單行.
	//2018-3-9 15:28:25注釋:已保存備份,以下用新方法快速關聯修改畫面
	//var GongXu = encodeURIComponent($("#WP").val());//工序

	var DT = $("#RiQi").val();//日期
	console.log(DT);
	var times;
	
	column=[
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true }
	];		
				
	colHeader=[				
		'機台號',
		'操機員',
		];
					
	colWidth=[		
		200,
		200,			
		];
	$('#mytable').jexcel({ data:Plan_data,
		// Allow column delete
		allowDeleteColumn:false,
		// Allow row dragging
		rowDrag:false,
		columns:column,
		colHeaders:colHeader,
		colWidths:colWidth
	});
	//默認日期(因為JS沒有日期格式化函數)
	var date = new Date
	hh=date.getHours();  //获取当前小时数(0-23)
	var mm = ""
	var dd = ""
	if ((date.getMonth()+1)>9){
		mm=(date.getMonth()+1)
	}else{
		mm=0+""+(date.getMonth()+1)
	};
	if ((date.getDate())>9&&hh<8){
		dd=(date.getDate()-1)
	}
	if ((date.getDate())>9&&hh>=8){
		dd=(date.getDate())
	}
	if ((date.getDate())<9&&hh>=8){
		dd=0+""+(date.getDate())
	}
	if ((date.getDate())<9&&hh>=8){
		dd=0+""+(date.getDate()-1)
	}

	$("#RiQi").val(date.getFullYear()+"-"+mm+"-"+dd);
	
	$("#ZhouBie").val(getWeekOfYear(date))
	
	
	//一天含86,400,000毫秒(24*60*60*1000)
	//公式計算获取本周是一年中的第几周
	function getWeekOfYear(date){
	    var d1 = date;
	    var d2 = new Date(date.getFullYear(), 0, 1);
	    var d = Math.round((d1 - d2) / 86400000);
	    return Math.ceil((d + ((d2.getDay() + 1) - 1)) / 7);
	};
	Working_Pro= (document.getElementById('WP')).value;//工序
	Shift = $('input[type="radio"][name="classRadios"]:checked').val();//班別
	Times=date.getFullYear()+"-"+mm+"-"+dd+"-"+hh;//時間
	$("#keep").click(function(){//保存
		
		longdata = $('#mytable').jexcel('getData', false); 
		 $.ajax({
			type:'POST',
			url: "Operator_Keep.php",//POST傳一個超長字串到後端
			data:"Working_Pro="+Working_Pro+"&Shift="+Shift+"&Times="+Times+"&ShuZu="+JSON.stringify(longdata),
			dataType : "text",
			success: function(data){
				$("#msg").val(data);
				CXdata=data;
				Plan_data = data;
			}
		}); 
	});
	
	$("#Yesterday_Work_People").click(function(){//查詢昨日操机员排配
		
	    Working_Pro= (document.getElementById('WP')).value;//工序
		Shift = $('input[type="radio"][name="classRadios"]:checked').val();//班別
	
		longdata = $('#mytable').jexcel('getData', false); 
		 $.ajax({
			type:'POST',
			url: "Operator_Keep.php",//POST傳一個超長字串到後端
			data:"Working_Pro="+Working_Pro+"&Shift="+Shift+"&Times="+Times+"&ShuZu="+JSON.stringify(longdata),
			dataType : "text",
			success: function(data){
				$("#msg").val(data);
				CXdata=data;
				Plan_data = data;
			}
		}); 
	});
</script>
	
</body>
</html>
